Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_JOIN_IND_COLUMNS

`ALL_JOIN_IND_COLUMNS` describes the join conditions of bitmap join indexes to which you have access. Bitmap join indexes are indexes built on a child table with an index key containing columns from associated parent tables, where all of the tables are connected through join conditions. There is one row for each join condition.

Related Views

- `DBA_JOIN_IND_COLUMNS` describes all join conditions exiting in the database.

- `USER_JOIN_IND_COLUMNS` describes join conditions owned by the current user. This view does not display the `INDEX_OWNER` column.

Column | Datatype | Description
--- | --- | ---
`INDEX_OWNER` | `VARCHAR2(30)` | Bitmap join index owner
`INDEX_NAME` | `VARCHAR2(30)` | Name of bitmap join index
`INNER_TABLE_OWNER` | `VARCHAR2(30)` | Fact table owner
`INNER_TABLE_NAME` | `VARCHAR2(30)` | Name of the fact table
`OUTER_TABLE_OWNER` | `VARCHAR2(30)` | Dimension table owner
`OUTER_TABLE_NAME` | `VARCHAR2(30)` | Name of the dimension table
`COL_NAME_INNER` | `VARCHAR2(4000)` | Name of the fact table join column
`COL_NAME_OUTER` | `VARCHAR2(4000)` | Name of the dimension table join column